Capital Bike Trip Data Quality Report

Brought to you by YData

Dataset statistics

Number of variables	13
Number of observations	664841
Missing cells	570417
Missing cells (%)	6.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	350.7 MiB
Average record size in memory	553.1 B

Variable types

Text	3
Categorical	2
DateTime	2
Numeric	6

Alerts

`end_lat` is highly overall correlated with `start_lat`	High correlation
`end_lng` is highly overall correlated with `start_lng`	High correlation
`start_lat` is highly overall correlated with `end_lat`	High correlation
`start_lng` is highly overall correlated with `end_lng`	High correlation
`start_station_name` has 139752 (21.0%) missing values	Missing
`start_station_id` has 139752 (21.0%) missing values	Missing
`end_station_name` has 144920 (21.8%) missing values	Missing
`end_station_id` has 145015 (21.8%) missing values	Missing
`end_lng` is highly skewed (γ1 = 248.6115777)	Skewed
`ride_id` has unique values	Unique

Reproduction

Analysis started	2025-05-04 18:31:44.792445
Analysis finished	2025-05-04 18:32:01.403064
Duration	16.61 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

ride_id
Text

Unique

Distinct	664841
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	46.3 MiB

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	10637456
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	664841 ?
Unique (%)	100.0%

Sample

1st row	9C4EFBCCA63C94D8
2nd row	302DB0DF65954B5A
3rd row	B8E500B89C4358DC
4th row	05771DAB5118E255
5th row	A0BAFC8706AD756F

Value	Count	Frequency (%)
9c4efbcca63c94d8	1	< 0.1%
f813364dde0ae483	1	< 0.1%
2de6b8d1a56a151c	1	< 0.1%
98f6b617e25798bf	1	< 0.1%
093fae32f60c1e45	1	< 0.1%
b8e500b89c4358dc	1	< 0.1%
05771dab5118e255	1	< 0.1%
a0bafc8706ad756f	1	< 0.1%
009bae9057af9068	1	< 0.1%
f2841b741a0f3d93	1	< 0.1%
Other values (664831)	664831	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
B	666241	6.3%
7	666133	6.3%
2	665876	6.3%
3	665582	6.3%
D	665277	6.3%
0	665219	6.3%
1	665090	6.3%
A	664611	6.2%
9	664492	6.2%
C	664491	6.2%
Other values (6)	3984444	37.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10637456	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	666241	6.3%
7	666133	6.3%
2	665876	6.3%
3	665582	6.3%
D	665277	6.3%
0	665219	6.3%
1	665090	6.3%
A	664611	6.2%
9	664492	6.2%
C	664491	6.2%
Other values (6)	3984444	37.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10637456	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	666241	6.3%
7	666133	6.3%
2	665876	6.3%
3	665582	6.3%
D	665277	6.3%
0	665219	6.3%
1	665090	6.3%
A	664611	6.2%
9	664492	6.2%
C	664491	6.2%
Other values (6)	3984444	37.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10637456	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	666241	6.3%
7	666133	6.3%
2	665876	6.3%
3	665582	6.3%
D	665277	6.3%
0	665219	6.3%
1	665090	6.3%
A	664611	6.2%
9	664492	6.2%
C	664491	6.2%
Other values (6)	3984444	37.5%

rideable_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	44.1 MiB

electric_bike	395735
classic_bike	269106

Length

Max length	13
Median length	13
Mean length	12.595233
Min length	12

Characters and Unicode

Total characters	8373827
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	classic_bike
2nd row	classic_bike
3rd row	classic_bike
4th row	electric_bike
5th row	electric_bike

Common Values

Value	Count	Frequency (%)
electric_bike	395735	59.5%
classic_bike	269106	40.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
electric_bike	395735	59.5%
classic_bike	269106	40.5%

Most occurring characters

Value	Count	Frequency (%)
e	1456311	17.4%
c	1329682	15.9%
i	1329682	15.9%
l	664841	7.9%
_	664841	7.9%
b	664841	7.9%
k	664841	7.9%
s	538212	6.4%
t	395735	4.7%
r	395735	4.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8373827	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1456311	17.4%
c	1329682	15.9%
i	1329682	15.9%
l	664841	7.9%
_	664841	7.9%
b	664841	7.9%
k	664841	7.9%
s	538212	6.4%
t	395735	4.7%
r	395735	4.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8373827	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1456311	17.4%
c	1329682	15.9%
i	1329682	15.9%
l	664841	7.9%
_	664841	7.9%
b	664841	7.9%
k	664841	7.9%
s	538212	6.4%
t	395735	4.7%
r	395735	4.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8373827	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1456311	17.4%
c	1329682	15.9%
i	1329682	15.9%
l	664841	7.9%
_	664841	7.9%
b	664841	7.9%
k	664841	7.9%
s	538212	6.4%
t	395735	4.7%
r	395735	4.7%

started_at
Date

Distinct	664697
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	5.1 MiB

Minimum	2024-08-31 00:14:28.111000
Maximum	2024-09-30 23:56:49.220000
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

ended_at
Date

Distinct	664648
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	5.1 MiB

Minimum	2024-09-01 00:00:14.521000
Maximum	2024-09-30 23:59:54.421000
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

start_station_name
Text

Missing

Distinct	779
Distinct (%)	0.1%
Missing	139752
Missing (%)	21.0%
Memory size	44.4 MiB

Length

Max length	61
Median length	50
Mean length	23.071792
Min length	10

Characters and Unicode

Total characters	12114744
Distinct characters	70
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Saint Asaph St & Madison St
2nd row	17th & K St NW / Farragut Square
3rd row	9th & N St NW
4th row	Eisenhower Ave & Mill Race Ln
5th row	Eisenhower Ave & Mill Race Ln

Value	Count	Frequency (%)
	548005	18.1%
st	432098	14.3%
nw	293651	9.7%
ave	158925	5.2%
ne	66786	2.2%
14th	38253	1.3%
se	32824	1.1%
n	31711	1.0%
new	31300	1.0%
rd	29707	1.0%
Other values (800)	1364236	45.1%

Most occurring characters

Value	Count	Frequency (%)
	2510833	20.7%
t	1055229	8.7%
e	624914	5.2%
S	544891	4.5%
&	484396	4.0%
n	463794	3.8%
a	453678	3.7%
N	450034	3.7%
r	417642	3.4%
o	410157	3.4%
Other values (60)	4699176	38.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12114744	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	2510833	20.7%
t	1055229	8.7%
e	624914	5.2%
S	544891	4.5%
&	484396	4.0%
n	463794	3.8%
a	453678	3.7%
N	450034	3.7%
r	417642	3.4%
o	410157	3.4%
Other values (60)	4699176	38.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12114744	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	2510833	20.7%
t	1055229	8.7%
e	624914	5.2%
S	544891	4.5%
&	484396	4.0%
n	463794	3.8%
a	453678	3.7%
N	450034	3.7%
r	417642	3.4%
o	410157	3.4%
Other values (60)	4699176	38.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12114744	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	2510833	20.7%
t	1055229	8.7%
e	624914	5.2%
S	544891	4.5%
&	484396	4.0%
n	463794	3.8%
a	453678	3.7%
N	450034	3.7%
r	417642	3.4%
o	410157	3.4%
Other values (60)	4699176	38.8%

start_station_id
Real number (ℝ)

Missing

Distinct	777
Distinct (%)	0.1%
Missing	139752
Missing (%)	21.0%
Infinite	0
Infinite (%)	0.0%
Mean	31380.29

Minimum	30200
Maximum	33200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 MiB

Quantile statistics

Minimum	30200
5-th percentile	31056
Q1	31209
median	31289
Q3	31609
95-th percentile	31929
Maximum	33200
Range	3000
Interquartile range (IQR)	400

Descriptive statistics

Standard deviation	287.86898
Coefficient of variation (CV)	0.0091735602
Kurtosis	4.085314
Mean	31380.29
Median Absolute Deviation (MAD)	170
Skewness	0.85627807
Sum	1.6477445 × 10¹⁰
Variance	82868.547
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31623	5467	0.8%
31229	5075	0.8%
31201	4546	0.7%
31600	4482	0.7%
31603	4439	0.7%
31101	4233	0.6%
31200	3703	0.6%
31627	3664	0.6%
31258	3605	0.5%
31236	3542	0.5%
Other values (767)	482333	72.5%
(Missing)	139752	21.0%

Value	Count	Frequency (%)
30200	1366	0.2%
30201	1670	0.3%
31000	583	0.1%
31002	710	0.1%
31003	585	0.1%
31004	253	< 0.1%
31005	836	0.1%
31006	724	0.1%
31007	780	0.1%
31009	250	< 0.1%

Value	Count	Frequency (%)
33200	688	0.1%
32901	27	< 0.1%
32609	42	< 0.1%
32608	59	< 0.1%
32607	45	< 0.1%
32606	153	< 0.1%
32605	83	< 0.1%
32604	59	< 0.1%
32603	48	< 0.1%
32602	40	< 0.1%

end_station_name
Text

Missing

Distinct	781
Distinct (%)	0.2%
Missing	144920
Missing (%)	21.8%
Memory size	44.1 MiB

Length

Max length	61
Median length	51
Mean length	23.021399
Min length	10

Characters and Unicode

Total characters	11969309
Distinct characters	70
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Market Square / King St & Royal St
2nd row	15th & W St NW
3rd row	Rhode Island Ave & 39th St / Brentwood Arts Exchange
4th row	Ballenger Ave & Dulaney St
5th row	Ballenger Ave & Dulaney St

Value	Count	Frequency (%)
	544009	18.1%
st	431537	14.4%
nw	289918	9.7%
ave	158796	5.3%
ne	66782	2.2%
14th	36576	1.2%
se	33543	1.1%
new	31631	1.1%
sw	30171	1.0%
m	30001	1.0%
Other values (802)	1349207	44.9%

Most occurring characters

Value	Count	Frequency (%)
	2490514	20.8%
t	1048159	8.8%
e	617753	5.2%
S	545507	4.6%
&	480613	4.0%
n	457158	3.8%
a	446153	3.7%
N	444714	3.7%
r	410484	3.4%
o	400604	3.3%
Other values (60)	4627650	38.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11969309	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	2490514	20.8%
t	1048159	8.8%
e	617753	5.2%
S	545507	4.6%
&	480613	4.0%
n	457158	3.8%
a	446153	3.7%
N	444714	3.7%
r	410484	3.4%
o	400604	3.3%
Other values (60)	4627650	38.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11969309	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	2490514	20.8%
t	1048159	8.8%
e	617753	5.2%
S	545507	4.6%
&	480613	4.0%
n	457158	3.8%
a	446153	3.7%
N	444714	3.7%
r	410484	3.4%
o	400604	3.3%
Other values (60)	4627650	38.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11969309	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	2490514	20.8%
t	1048159	8.8%
e	617753	5.2%
S	545507	4.6%
&	480613	4.0%
n	457158	3.8%
a	446153	3.7%
N	444714	3.7%
r	410484	3.4%
o	400604	3.3%
Other values (60)	4627650	38.7%

end_station_id
Real number (ℝ)

Missing

Distinct	778
Distinct (%)	0.1%
Missing	145015
Missing (%)	21.8%
Infinite	0
Infinite (%)	0.0%
Mean	31381.767

Minimum	30200
Maximum	33200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 MiB

Quantile statistics

Minimum	30200
5-th percentile	31060
Q1	31212
median	31289
Q3	31611
95-th percentile	31928
Maximum	33200
Range	3000
Interquartile range (IQR)	399

Descriptive statistics

Standard deviation	288.86454
Coefficient of variation (CV)	0.0092048525
Kurtosis	4.2357769
Mean	31381.767
Median Absolute Deviation (MAD)	170
Skewness	0.81349061
Sum	1.6313059 × 10¹⁰
Variance	83442.722
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31623	5439	0.8%
31229	4998	0.8%
31201	4557	0.7%
31600	4556	0.7%
31603	4460	0.7%
31101	4169	0.6%
31627	3723	0.6%
31200	3720	0.6%
31236	3582	0.5%
31613	3429	0.5%
Other values (768)	477193	71.8%
(Missing)	145015	21.8%

Value	Count	Frequency (%)
30200	1609	0.2%
30201	1709	0.3%
31000	608	0.1%
31002	712	0.1%
31003	582	0.1%
31004	253	< 0.1%
31005	830	0.1%
31006	732	0.1%
31007	771	0.1%
31009	256	< 0.1%

Value	Count	Frequency (%)
33200	702	0.1%
32901	80	< 0.1%
32609	38	< 0.1%
32608	67	< 0.1%
32607	52	< 0.1%
32606	129	< 0.1%
32605	80	< 0.1%
32604	62	< 0.1%
32603	58	< 0.1%
32602	44	< 0.1%

start_lat
Real number (ℝ)

High correlation

Distinct	34881
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.906499

Minimum	38.74
Maximum	39.13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 MiB

Quantile statistics

Minimum	38.74
5-th percentile	38.862841
Q1	38.89245
median	38.905578
Q3	38.92
95-th percentile	38.953691
Maximum	39.13
Range	0.39
Interquartile range (IQR)	0.027549906

Descriptive statistics

Standard deviation	0.029197204
Coefficient of variation (CV)	0.00075044543
Kurtosis	5.7108485
Mean	38.906499
Median Absolute Deviation (MAD)	0.0144215
Skewness	0.38571918
Sum	25866636
Variance	0.00085247674
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.9	20983	3.2%
38.91	20433	3.1%
38.92	18416	2.8%
38.93	15592	2.3%
38.88	9324	1.4%
38.94	8642	1.3%
38.89	8151	1.2%
38.95	7990	1.2%
38.96	7254	1.1%
38.89696	5223	0.8%
Other values (34871)	542833	81.6%

Value	Count	Frequency (%)
38.74	13	< 0.1%
38.76	29	< 0.1%
38.76552765	1	< 0.1%
38.766844	26	< 0.1%
38.76687503	1	< 0.1%
38.76687562	1	< 0.1%
38.76688898	1	< 0.1%
38.76691317	1	< 0.1%
38.766946	65	< 0.1%
38.76843	15	< 0.1%

Value	Count	Frequency (%)
39.13	17	< 0.1%
39.12582811	26	< 0.1%
39.123513	14	< 0.1%
39.12333798	1	< 0.1%
39.12333	23	< 0.1%
39.121327	35	< 0.1%
39.12124586	1	< 0.1%
39.121104	1	< 0.1%
39.12	60	< 0.1%
39.11988258	1	< 0.1%

start_lng
Real number (ℝ)

High correlation

Distinct	35211
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-77.03277

Minimum	-77.39
Maximum	-76.825416
Zeros	0
Zeros (%)	0.0%
Negative	664841
Negative (%)	100.0%
Memory size	5.1 MiB

Quantile statistics

Minimum	-77.39
5-th percentile	-77.091862
Q1	-77.045
median	-77.03
Q3	-77.011616
95-th percentile	-76.987823
Maximum	-76.825416
Range	0.56458391
Interquartile range (IQR)	0.033384

Descriptive statistics

Standard deviation	0.037667961
Coefficient of variation (CV)	-0.00048898619
Kurtosis	16.606255
Mean	-77.03277
Median Absolute Deviation (MAD)	0.016912611
Skewness	-2.4745639
Sum	-51214544
Variance	0.0014188753
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-77.03	28869	4.3%
-77.02	18417	2.8%
-77.04	16154	2.4%
-77	12167	1.8%
-77.01	10959	1.6%
-77.05	6794	1.0%
-76.99	5922	0.9%
-77.07	5296	0.8%
-77.00493	5223	0.8%
-77.06	4989	0.8%
Other values (35201)	550051	82.7%

Value	Count	Frequency (%)
-77.39	2	< 0.1%
-77.38	3	< 0.1%
-77.37	43	< 0.1%
-77.368416	50	< 0.1%
-77.36837947	1	< 0.1%
-77.36800253	1	< 0.1%
-77.36786842	5	< 0.1%
-77.36663961	1	< 0.1%
-77.366499	29	< 0.1%
-77.3662945	1	< 0.1%

Value	Count	Frequency (%)
-76.82541609	1	< 0.1%
-76.825535	21	< 0.1%
-76.83	18	< 0.1%
-76.8387907	1	< 0.1%
-76.84	29	< 0.1%
-76.843263	18	< 0.1%
-76.84326744	1	< 0.1%
-76.84326827	1	< 0.1%
-76.844604	49	< 0.1%
-76.85	6	< 0.1%

end_lat
Real number (ℝ)

High correlation

Distinct	834
Distinct (%)	0.1%
Missing	489
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	38.905888

Minimum	35.84
Maximum	42.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.1 MiB

Quantile statistics

Minimum	35.84
5-th percentile	38.862398
Q1	38.892275
median	38.905303
Q3	38.919018
95-th percentile	38.952369
Maximum	42.99
Range	7.15
Interquartile range (IQR)	0.0267435

Descriptive statistics

Standard deviation	0.030324128
Coefficient of variation (CV)	0.00077942258
Kurtosis	953.01831
Mean	38.905888
Median Absolute Deviation (MAD)	0.013506
Skewness	2.9438704
Sum	25847204
Variance	0.00091955271
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.9	21403	3.2%
38.91	21049	3.2%
38.92	19028	2.9%
38.93	16127	2.4%
38.88	9561	1.4%
38.94	8856	1.3%
38.89	8562	1.3%
38.95	8189	1.2%
38.96	7456	1.1%
38.89696	5439	0.8%
Other values (824)	538682	81.0%

Value	Count	Frequency (%)
35.84	1	< 0.1%
36.07	1	< 0.1%
38.63	1	< 0.1%
38.67	1	< 0.1%
38.71	7	< 0.1%
38.72	3	< 0.1%
38.73	2	< 0.1%
38.74	19	< 0.1%
38.75	3	< 0.1%
38.76	25	< 0.1%

Value	Count	Frequency (%)
42.99	1	< 0.1%
42.08	1	< 0.1%
39.28	1	< 0.1%
39.25	1	< 0.1%
39.13	16	< 0.1%
39.12582811	25	< 0.1%
39.123513	11	< 0.1%
39.12333	19	< 0.1%
39.121327	34	< 0.1%
39.12	61	< 0.1%

end_lng
Real number (ℝ)

High correlation Skewed

Distinct	855
Distinct (%)	0.1%
Missing	489
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-77.03249

Minimum	-80.18
Maximum	-48.7
Zeros	0
Zeros (%)	0.0%
Negative	664352
Negative (%)	99.9%
Memory size	5.1 MiB

Quantile statistics

Minimum	-80.18
5-th percentile	-77.09
Q1	-77.045
median	-77.03
Q3	-77.010266
95-th percentile	-76.987633
Maximum	-48.7
Range	31.48
Interquartile range (IQR)	0.034734

Descriptive statistics

Standard deviation	0.051552333
Coefficient of variation (CV)	-0.00066922844
Kurtosis	137357.31
Mean	-77.03249
Median Absolute Deviation (MAD)	0.017317624
Skewness	248.61158
Sum	-51176688
Variance	0.002657643
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-77.03	29865	4.5%
-77.02	18919	2.8%
-77.04	16687	2.5%
-77	12484	1.9%
-77.01	11333	1.7%
-77.05	7016	1.1%
-76.99	6209	0.9%
-77.07	5455	0.8%
-77.00493	5439	0.8%
-77.06	5059	0.8%
Other values (845)	545886	82.1%

Value	Count	Frequency (%)
-80.18	1	< 0.1%
-78.69	1	< 0.1%
-78.29	1	< 0.1%
-77.68	1	< 0.1%
-77.49	1	< 0.1%
-77.4	1	< 0.1%
-77.39	3	< 0.1%
-77.38	2	< 0.1%
-77.37	44	< 0.1%
-77.368416	53	< 0.1%

Value	Count	Frequency (%)
-48.7	1	< 0.1%
-74.75	1	< 0.1%
-76.51	1	< 0.1%
-76.74	1	< 0.1%
-76.76	1	< 0.1%
-76.78	1	< 0.1%
-76.825535	19	< 0.1%
-76.83	25	< 0.1%
-76.84	34	< 0.1%
-76.843263	19	< 0.1%

member_casual
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.9 MiB

member	435233
casual	229608

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	3989046
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	member
2nd row	member
3rd row	casual
4th row	member
5th row	member

Common Values

Value	Count	Frequency (%)
member	435233	65.5%
casual	229608	34.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
member	435233	65.5%
casual	229608	34.5%

Most occurring characters

Value	Count	Frequency (%)
m	870466	21.8%
e	870466	21.8%
a	459216	11.5%
b	435233	10.9%
r	435233	10.9%
c	229608	5.8%
s	229608	5.8%
u	229608	5.8%
l	229608	5.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3989046	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
m	870466	21.8%
e	870466	21.8%
a	459216	11.5%
b	435233	10.9%
r	435233	10.9%
c	229608	5.8%
s	229608	5.8%
u	229608	5.8%
l	229608	5.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3989046	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
m	870466	21.8%
e	870466	21.8%
a	459216	11.5%
b	435233	10.9%
r	435233	10.9%
c	229608	5.8%
s	229608	5.8%
u	229608	5.8%
l	229608	5.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3989046	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
m	870466	21.8%
e	870466	21.8%
a	459216	11.5%
b	435233	10.9%
r	435233	10.9%
c	229608	5.8%
s	229608	5.8%
u	229608	5.8%
l	229608	5.8%

	end_lat	end_lng	end_station_id	member_casual	rideable_type	start_lat	start_lng	start_station_id
end_lat	1.000	-0.018	-0.128	0.000	0.000	0.736	0.007	-0.057
end_lng	-0.018	1.000	0.453	0.041	0.044	0.000	0.732	0.318
end_station_id	-0.128	0.453	1.000	0.087	0.046	-0.068	0.312	0.369
member_casual	0.000	0.041	0.087	1.000	0.015	0.106	0.059	0.091
rideable_type	0.000	0.044	0.046	0.015	1.000	0.186	0.075	0.053
start_lat	0.736	0.000	-0.068	0.106	0.186	1.000	-0.019	-0.115
start_lng	0.007	0.732	0.312	0.059	0.075	-0.019	1.000	0.452
start_station_id	-0.057	0.318	0.369	0.091	0.053	-0.115	0.452	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	ride_id	rideable_type	started_at	ended_at	start_station_name	start_station_id	end_station_name	end_station_id	start_lat	start_lng	end_lat	end_lng	member_casual
0	9C4EFBCCA63C94D8	classic_bike	2024-09-03 14:02:18.985	2024-09-03 14:06:30.572	Saint Asaph St & Madison St	31097.0	Market Square / King St & Royal St	31042.0	38.812718	-77.044097	38.804718	-77.043363	member
1	302DB0DF65954B5A	classic_bike	2024-09-27 17:12:06.899	2024-09-27 17:25:46.530	17th & K St NW / Farragut Square	31233.0	15th & W St NW	31125.0	38.902061	-77.038322	38.919018	-77.034449	member
2	B8E500B89C4358DC	classic_bike	2024-09-27 18:05:43.871	2024-09-27 18:43:56.051	9th & N St NW	31336.0	Rhode Island Ave & 39th St / Brentwood Arts Exchange	32413.0	38.906622	-77.023885	38.939271	-76.955047	casual
3	05771DAB5118E255	electric_bike	2024-09-13 14:57:35.417	2024-09-13 15:00:11.060	Eisenhower Ave & Mill Race Ln	31082.0	Ballenger Ave & Dulaney St	31084.0	38.801111	-77.068952	38.802677	-77.063562	member
4	A0BAFC8706AD756F	electric_bike	2024-09-13 09:04:49.266	2024-09-13 09:06:55.120	Eisenhower Ave & Mill Race Ln	31082.0	Ballenger Ave & Dulaney St	31084.0	38.801111	-77.068952	38.802677	-77.063562	member
5	009BAE9057AF9068	electric_bike	2024-09-29 17:17:52.281	2024-09-29 17:26:10.395	2nd St & Massachusetts Ave NE	31641.0	13th & E St SE	31607.0	38.894972	-77.003135	38.882915	-76.987907	member
6	F2841B741A0F3D93	classic_bike	2024-09-26 08:57:59.104	2024-09-26 09:01:16.587	Eisenhower Ave & Mill Race Ln	31082.0	Ballenger Ave & Dulaney St	31084.0	38.801111	-77.068952	38.802677	-77.063562	member
7	1A4241FFFA6EEEE6	electric_bike	2024-09-11 08:54:26.865	2024-09-11 08:56:20.829	Eisenhower Ave & Mill Race Ln	31082.0	Ballenger Ave & Dulaney St	31084.0	38.801111	-77.068952	38.802677	-77.063562	member
8	A925A49B6E431C74	classic_bike	2024-09-22 17:29:37.406	2024-09-22 17:35:46.403	1st & K St NE	31662.0	5th & K St NW	31600.0	38.902386	-77.005649	38.902734	-77.019181	member
9	093FAE32F60C1E45	electric_bike	2024-09-23 18:18:20.233	2024-09-23 18:24:03.605	Friendship Hts Metro / Wisconsin Ave & Wisconsin Cir	32014.0	Connecticut Ave & McKinley St NW	31315.0	38.961763	-77.085998	38.964544	-77.075135	member

	ride_id	rideable_type	started_at	ended_at	start_station_name	start_station_id	end_station_name	end_station_id	start_lat	start_lng	end_lat	end_lng	member_casual
664831	73B124E9F7532452	electric_bike	2024-09-15 20:34:16.414	2024-09-15 20:46:22.981	NaN	NaN	NaN	NaN	38.85	-76.97	38.85	-76.98	member
664832	E0732775F6664738	electric_bike	2024-09-15 22:14:16.104	2024-09-15 22:29:38.215	NaN	NaN	NaN	NaN	38.85	-76.98	38.88	-76.97	member
664833	B4C52DDB80BC45C7	electric_bike	2024-09-15 23:51:16.742	2024-09-16 00:00:21.009	NaN	NaN	NaN	NaN	38.88	-76.93	38.88	-76.93	member
664834	B87AC79F0732D076	electric_bike	2024-09-16 19:56:24.529	2024-09-16 20:48:01.618	NaN	NaN	NaN	NaN	38.85	-76.98	38.85	-76.98	member
664835	F7FB65FE36ABFDC6	electric_bike	2024-09-16 10:53:53.280	2024-09-16 11:25:21.797	NaN	NaN	NaN	NaN	38.91	-76.93	38.85	-76.98	member
664836	4C2859F401A89BE4	electric_bike	2024-09-16 17:23:10.553	2024-09-16 18:15:01.087	NaN	NaN	NaN	NaN	38.88	-77.00	38.90	-76.92	member
664837	36C4ADE33349BF44	electric_bike	2024-09-16 08:59:39.257	2024-09-16 09:18:16.610	NaN	NaN	NaN	NaN	38.88	-76.93	38.85	-76.98	member
664838	F01550D1A53887E1	electric_bike	2024-09-16 06:42:03.153	2024-09-16 06:58:53.820	NaN	NaN	NaN	NaN	38.93	-77.04	38.90	-77.01	member
664839	5D3E7F1E248D4781	electric_bike	2024-09-16 14:56:28.251	2024-09-16 14:59:51.050	NaN	NaN	NaN	NaN	38.93	-77.04	38.94	-77.04	member
664840	43524A3F14B4411D	electric_bike	2024-09-16 15:03:28.717	2024-09-16 15:08:38.661	NaN	NaN	NaN	NaN	38.94	-77.04	38.93	-77.03	member

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample